package org.neuedu.ssmp.crm.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Select;
import org.neuedu.ssmp.crm.entity.SysUser;
import org.neuedu.ssmp.crm.entity.Tji;

import java.util.List;

public interface TjiMapper extends BaseMapper<Tji> {
    @Select("select COUNT(s.name) sun,a.name from customer_level a left JOIN customer s on a.id = s.level_id GROUP BY a.name")
//    @Select("select * from customer")
    List<Tji> hh();
    @Select("select agree_level,count(agree_level) sun from customer group by agree_level")
    List<Tji> hh1();
    @Select("select credit_level,count(credit_level) sun from customer group by credit_level")
    List<Tji> hh2();

}
